﻿<?xml version="1.0" encoding="utf-8" ?>
<bulkload
	schema="5"> <!-- required schema version, OPTIONAL -->

	<!--
	<table
		name:			name of table to insert data into
						REQUIRED
		
		truncate:		true/false whether to truncate the table before
						inserting data
						OPTIONAL, DEFAULT = false
						
		deleteWhere:	the SQL WHERE clause to use to delete data from
						the table before inserting data
						OPTIONAL, DEFAULT will not perform delete
						
		identityInsert:	true/false whether we need to SET IDENTITY_INSERT ON
						for the table before inserting data (will be turned off when complete)
						OPTIONAL, DEFAULT = false
	</table>
	-->
	<table
		name="StateLookup"
		truncate="true"
		identityInsert="true">

		<!--
		<row />
			each attribute on the <row /> is expected to be a column name,
			the value of the attribute is the value that will be
			inserted into that column.
		-->
		<row StateID="1" Name="Kansas" Abbr="KS" />
		<row StateID="2" Name="Indiana" Abbr="IN" />
		
	</table>

	<table
		name="CityLookup"
		deleteWhere="Name='Springfield'">

		<row Name="Jeffersonville" />
		<row Name="Tulsa" />
		<row Name="Springfield" />
		
	</table>		
	
</bulkload>